package leaveSystem.dao;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Date;
import java.util.List;

import leaveSystem.model.PublicHolidays;

public interface PublicHolidaysDAO {
	
	public List<PublicHolidays> loadAll(Connection conn) throws SQLException;
	public void insertPublicHolidays(Connection conn, PublicHolidays valueObject) throws SQLException;
	public void updatePublicHolidays(Connection conn, PublicHolidays valueObject) throws DAOException, SQLException;
	public void deletePublicHolidays(Connection conn, PublicHolidays valueObject) throws DAOException, SQLException;
	public void deleteAllPublicHolidays(Connection conn) throws SQLException;
	public List<PublicHolidays> findPublicHolidays(Connection conn, PublicHolidays valueObject) throws SQLException;
	public List<PublicHolidays> findPublicHolidaysByDates(Connection conn,String start,String end) throws Exception;
}
